Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Analytical Functions
1) A summary query that includes a final summary row with WITH CUBE
2) A summary query that includes a final summary row with WITH ROLLUP
3) A summary query that includes a summary row for each grouping level
4) A summary query that includes a summary row for each set of groups
5) Aggregate Functions STDEV and STDEVP
6) COMPUTE MIN(start_date) BY region
7) Creating the Vbase_cube View to Hide the CUBE Query Complexity
8) CUBE performs this rollup for every combination of grouped column values
9) DENSE_RANK() OVER
10) Group hierarchy using the ROLLUP operator is determined by the order in which the grouping columns are specified
11) GROUPING() Comes to the Rescue
12) GROUPING() function returns a bit value (1 or 0) to indicate that a row is a rollup
13) PIVOT and UNPIVOT Operators
14) Replacing NULLs with ALL and UNKNOWN
15) ROLLUP Returns Super Aggregation Only in One Direction
16) ROW_NUMBER function returns the sequential number of a row within a result set, starting at 1 for the first row
17) STDEV returns the standard deviation of all the values provided in the expression, based on a sample of the data popu
18) STDEV() Function is a calculation based on the variance of a numeric range of values
19) Summarizing Data with CUBE
20) Summarizing Data with ROLLUP
21) The aggregate function STDEVP computes the standard deviation for the population of all the values listed in a column
22) The STDEVP function returns the standard deviation for all values in the provided expression
23) The syntax of the GROUPING function
24) The use of multiple aggregate functions in a COMPUTE clause
25) The use of the COMPUTE clause, with and without the BY portion
26) The VAR() return the measure of how far the extreme low range or high range value is from the middle
27) Using an Incrementing Row Number
28) Using COMPUTE with aggregate functions
29) Using GROUPING with CUBE
30) Using NTILE
31) Using ROLLUP to Get the Order Count by Year and Month
32) Using several columns from a table to build different partitioning schemas in a query
33) Using Statistical Aggregate Functions
34) Using the COMPUTE BY to provide subtotals
35) Using the CUBE Operator
36) Using the ROLLUP Operator
37) VAR computes the variance of all the values listed in a column or expression
38) WITH ROLLUP for calculating subtotals and totals on the first column in the GROUP BY column list
39) Window function can be a ranking function
40) Window function can be an aggregate function